---
title: DB-CLL-021 — Insert a new case outcome
summary: Insert a new case outcome
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-021 — Insert a new case outcome

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-021 |
| Operation type | I |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsCaseOutcome |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| CaseOutcomeID | ReturnValue | NUMBER | N/A | New case outcome identifier |
| LegalCaseID | Input | NUMBER | N/A | Owning legal case identifier |
| OutcomeDate | Input | DATE | N/A | Date of the outcome |
| OutcomeTypeCode | Input | VARCHAR2 | N/A | Type of outcome |
| CreateUser | Input | VARCHAR2 | N/A | User creating the row |
| CreateDate | Input | DATE | N/A | Row creation timestamp |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CASE_OUTCOME](../database-tables.md#case_outcome) | INSERT | ~10 columns |

## Sample SQL

```sql
EXEC pk80001_legalnet.InsertCaseOutcome(:CaseOutcomeID OUT, :LegalCaseID, :OutcomeDate,
  :OutcomeTypeCode, :CreateUser, :CreateDate, :HearingLocationSeqNum, :DecisionCode,
  :ReviewLevelCode, :Comments);  -- final 4 params inferred from remaining case-outcome detail columns*
```

## Operations and processes

- [Manage case outcomes, issues, and staff](../operations/manage-case-outcome.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb`